{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9f9b6185-531a-4608-b6f7-15338e445a54",
   "metadata": {},
   "outputs": [],
   "source": [
    "var openDigger = require('../src/open_digger');"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e8ebfa1b-677a-48d4-8a86-471735bdaa80",
   "metadata": {},
   "source": [
    "# 中国开源年报\n",
    "\n",
    "该 Notebook 用于生成中国开源年报相关数据。如：\n",
    "\n",
    "- [2021 中国开源年度报告](https://kaiyuanshe.cn/document/china-os-report-2021/2021%20%E4%B8%AD%E5%9B%BD%E5%BC%80%E6%BA%90%E5%B9%B4%E5%BA%A6%E6%8A%A5%E5%91%8A.pdf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6a8399aa-df62-451f-8558-a4609b37d365",
   "metadata": {},
   "outputs": [],
   "source": [
    "var startYear = 2021, startMonth = 1, endYear = 2021, endMonth = 12, groupTimeRange = 'year', order = 'DESC';"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c5ad5c28-b200-4d9d-bd36-0e39ecfdd97f",
   "metadata": {},
   "source": [
    "## 世界活跃度排名 Top 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e369cb2e-2bba-4d7b-a536-15c6b52d0c17",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────┬────────────────────────────┬──────────────┬──────────────┬───────────────┬─────────────┬─────────────┬────────────────┬─────────────┐\n",
      "│ (index) │     id      │            name            │   activity   │ participants │ issue_comment │ open_issue  │  open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────┼────────────────────────────┼──────────────┼──────────────┼───────────────┼─────────────┼─────────────┼────────────────┼─────────────┤\n",
      "│    0    │  '4542716'  │      'NixOS/nixpkgs'       │ [ 47472.49 ] │ [ '12728' ]  │  [ '99845' ]  │ [ '4187' ]  │ [ '36709' ] │  [ '43856' ]   │ [ '32600' ] │\n",
      "│    1    │ '31792824'  │     'flutter/flutter'      │ [ 44657.11 ] │ [ '23677' ]  │ [ '134253' ]  │ [ '14270' ] │ [ '6788' ]  │  [ '10768' ]   │ [ '4667' ]  │\n",
      "│    2    │ '41881900'  │     'microsoft/vscode'     │ [ 42994.26 ] │ [ '24810' ]  │  [ '87026' ]  │ [ '21874' ] │ [ '2340' ]  │   [ '3137' ]   │ [ '1728' ]  │\n",
      "│    3    │ '12888993'  │   'home-assistant/core'    │ [ 40663.72 ] │ [ '18326' ]  │  [ '78494' ]  │ [ '6758' ]  │ [ '9828' ]  │  [ '33381' ]   │ [ '8500' ]  │\n",
      "│    4    │ '72685026'  │ 'MicrosoftDocs/azure-docs' │ [ 38679.68 ] │ [ '20119' ]  │  [ '57774' ]  │ [ '11473' ] │ [ '4732' ]  │   [ '1156' ]   │ [ '2955' ]  │\n",
      "│    5    │ '20580498'  │  'kubernetes/kubernetes'   │ [ 31653.37 ] │ [ '10090' ]  │ [ '170297' ]  │ [ '2688' ]  │ [ '6234' ]  │  [ '28311' ]   │ [ '4124' ]  │\n",
      "│    6    │ '210716005' │      'dotnet/runtime'      │ [ 29483.98 ] │  [ '8698' ]  │  [ '84588' ]  │ [ '7271' ]  │ [ '7783' ]  │  [ '33139' ]   │ [ '6709' ]  │\n",
      "│    7    │ '65600975'  │     'pytorch/pytorch'      │ [ 29398.91 ] │  [ '9192' ]  │  [ '83075' ]  │ [ '5553' ]  │ [ '13113' ] │  [ '37364' ]   │  [ '502' ]  │\n",
      "│    8    │  '7833168'  │      'elastic/kibana'      │ [ 28635.48 ] │  [ '5079' ]  │ [ '144530' ]  │ [ '9710' ]  │ [ '21571' ] │  [ '37248' ]   │ [ '20079' ] │\n",
      "│    9    │  '724712'   │      'rust-lang/rust'      │ [ 24633.75 ] │  [ '8033' ]  │  [ '96167' ]  │ [ '4353' ]  │ [ '6509' ]  │  [ '18176' ]   │ [ '2759' ]  │\n",
      "└─────────┴─────────────┴────────────────────────────┴──────────────┴──────────────┴───────────────┴─────────────┴─────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({startYear, endYear, startMonth, endMonth, groupTimeRange, order, limit: 10 }).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "998ca7fb-1ee5-4955-84a7-278969da7d2a",
   "metadata": {},
   "source": [
    "## 中国活跃度排名 Top 30"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3ab8708d-cf53-432c-b34e-2f17fee5ffc8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────┬───────────────────────────────────┬──────────────┬──────────────┬───────────────┬────────────┬────────────┬────────────────┬─────────────┐\n",
      "│ (index) │     id      │               name                │   activity   │ participants │ issue_comment │ open_issue │ open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────┼───────────────────────────────────┼──────────────┼──────────────┼───────────────┼────────────┼────────────┼────────────────┼─────────────┤\n",
      "│    0    │ '65711522'  │       'PaddlePaddle/Paddle'       │ [ 13293.82 ] │  [ '3974' ]  │  [ '19655' ]  │ [ '1873' ] │ [ '5955' ] │  [ '10121' ]   │ [ '4062' ]  │\n",
      "│    1    │ '41986369'  │          'pingcap/tidb'           │ [ 11446.08 ] │  [ '2104' ]  │  [ '63592' ]  │ [ '3425' ] │ [ '4880' ] │  [ '11543' ]   │ [ '3833' ]  │\n",
      "│    2    │ '34526884'  │      'ant-design/ant-design'      │ [ 8770.41 ]  │  [ '5044' ]  │  [ '13693' ]  │ [ '2682' ] │ [ '1321' ] │   [ '1072' ]   │  [ '959' ]  │\n",
      "│    3    │ '20587599'  │          'apache/flink'           │ [ 8514.56 ]  │  [ '1625' ]  │  [ '14559' ]  │  [ '0' ]   │ [ '3414' ] │  [ '14580' ]   │ [ '1590' ]  │\n",
      "│    4    │ '62117812'  │          'apache/pulsar'          │ [ 6828.53 ]  │  [ '1761' ]  │  [ '13494' ]  │ [ '1361' ] │ [ '2761' ] │   [ '6922' ]   │ [ '2374' ]  │\n",
      "│    5    │ '70746484'  │           'apache/tvm'            │ [ 6325.89 ]  │  [ '1413' ]  │  [ '7297' ]   │ [ '394' ]  │ [ '1975' ] │   [ '8974' ]   │ [ '1731' ]  │\n",
      "│    6    │ '262296122' │     'PaddlePaddle/PaddleOCR'      │ [ 5374.82 ]  │  [ '2462' ]  │  [ '8411' ]   │ [ '2422' ] │ [ '836' ]  │   [ '643' ]    │  [ '695' ]  │\n",
      "│    7    │ '208728772' │        'milvus-io/milvus'         │ [ 5047.83 ]  │  [ '967' ]   │  [ '30913' ]  │ [ '1990' ] │ [ '6119' ] │   [ '906' ]    │ [ '5617' ]  │\n",
      "│    8    │ '145670234' │     'open-mmlab/mmdetection'      │ [ 5009.45 ]  │  [ '2253' ]  │  [ '6830' ]   │ [ '1677' ] │ [ '662' ]  │   [ '2799' ]   │  [ '496' ]  │\n",
      "│    9    │ '49876476'  │      'apache/shardingsphere'      │ [ 4953.53 ]  │  [ '1442' ]  │  [ '8845' ]   │ [ '1794' ] │ [ '3251' ] │   [ '2417' ]   │ [ '2985' ]  │\n",
      "│   10    │ '48833910'  │            'tikv/tikv'            │ [ 4766.95 ]  │  [ '1018' ]  │  [ '18779' ]  │ [ '636' ]  │ [ '1511' ] │   [ '4472' ]   │ [ '1104' ]  │\n",
      "│   11    │ '137451403' │          'alibaba/nacos'          │ [ 4643.61 ]  │  [ '2296' ]  │  [ '6793' ]   │ [ '1786' ] │ [ '947' ]  │   [ '499' ]    │  [ '662' ]  │\n",
      "│   12    │ '183895098' │    'ant-design/pro-components'    │ [ 4377.32 ]  │  [ '2152' ]  │  [ '7679' ]   │ [ '1978' ] │ [ '731' ]  │   [ '171' ]    │  [ '668' ]  │\n",
      "│   13    │ '128624453' │           'NervJS/taro'           │ [ 4361.71 ]  │  [ '2435' ]  │  [ '5395' ]   │ [ '1402' ] │ [ '760' ]  │   [ '199' ]    │  [ '581' ]  │\n",
      "│   14    │  '9185792'  │         'apache/echarts'          │ [ 4323.98 ]  │  [ '2344' ]  │  [ '8031' ]   │ [ '1898' ] │ [ '319' ]  │   [ '375' ]    │  [ '261' ]  │\n",
      "│   15    │ '81634683'  │       'Oneflow-Inc/oneflow'       │ [ 4271.88 ]  │  [ '518' ]   │  [ '4519' ]   │ [ '191' ]  │ [ '2652' ] │  [ '11129' ]   │ [ '2094' ]  │\n",
      "│   16    │ '180481986' │          'apache/apisix'          │ [ 4106.58 ]  │  [ '1232' ]  │  [ '7007' ]   │ [ '1177' ] │ [ '1213' ] │   [ '4140' ]   │ [ '1043' ]  │\n",
      "│   17    │ '64188788'  │         'pingcap/docs-cn'         │  [ 4006.5 ]  │  [ '901' ]   │  [ '13601' ]  │  [ '99' ]  │ [ '2573' ] │   [ '5610' ]   │ [ '2180' ]  │\n",
      "│   18    │ '173335706' │     'apache/dolphinscheduler'     │ [ 3869.77 ]  │  [ '1184' ]  │  [ '10237' ]  │ [ '1472' ] │ [ '1554' ] │   [ '1434' ]   │ [ '1264' ]  │\n",
      "│   19    │ '217475193' │  'PaddlePaddle/PaddleDetection'   │  [ 3843.4 ]  │  [ '1392' ]  │  [ '5996' ]   │ [ '1689' ] │ [ '1198' ] │   [ '1314' ]   │  [ '989' ]  │\n",
      "│   20    │ '50613991'  │         'goharbor/harbor'         │ [ 3612.97 ]  │  [ '1799' ]  │  [ '4861' ]   │ [ '1212' ] │ [ '813' ]  │   [ '654' ]    │  [ '710' ]  │\n",
      "│   21    │ '237867883' │     'metersphere/metersphere'     │ [ 3555.69 ]  │  [ '1320' ]  │  [ '6346' ]   │ [ '2618' ] │ [ '4413' ] │    [ '3' ]     │ [ '3941' ]  │\n",
      "│   22    │ '196353673' │        'taosdata/TDengine'        │ [ 3489.01 ]  │  [ '1034' ]  │  [ '2426' ]   │ [ '643' ]  │ [ '3602' ] │   [ '392' ]    │ [ '3219' ]  │\n",
      "│   23    │  '4710920'  │          'apache/dubbo'           │ [ 3313.12 ]  │  [ '1277' ]  │  [ '5179' ]   │ [ '882' ]  │ [ '1328' ] │   [ '1006' ]   │ [ '1132' ]  │\n",
      "│   24    │  '7276954'  │         'Alluxio/alluxio'         │ [ 3246.11 ]  │  [ '659' ]   │  [ '7425' ]   │ [ '459' ]  │ [ '1431' ] │   [ '3780' ]   │ [ '1230' ]  │\n",
      "│   25    │ '101394335' │    'ant-design/ant-design-pro'    │ [ 3221.89 ]  │  [ '1849' ]  │  [ '4622' ]   │ [ '1425' ] │  [ '90' ]  │    [ '12' ]    │  [ '53' ]   │\n",
      "│   26    │ '113404957' │ 'kata-containers/kata-containers' │ [ 3178.86 ]  │  [ '740' ]   │  [ '8494' ]   │ [ '1017' ] │ [ '934' ]  │   [ '2646' ]   │  [ '727' ]  │\n",
      "│   27    │ '135516270' │           'k3s-io/k3s'            │ [ 3173.79 ]  │  [ '1436' ]  │  [ '5465' ]   │ [ '990' ]  │ [ '694' ]  │   [ '1103' ]   │  [ '624' ]  │\n",
      "│   28    │ '45721011'  │        'apache/skywalking'        │ [ 3165.48 ]  │  [ '1054' ]  │  [ '5809' ]   │ [ '926' ]  │ [ '783' ]  │   [ '2890' ]   │  [ '689' ]  │\n",
      "│   29    │ '62722937'  │   'tencentyun/qcloud-documents'   │ [ 3097.85 ]  │  [ '961' ]   │   [ '244' ]   │  [ '54' ]  │ [ '3570' ] │    [ '8' ]     │ [ '3223' ]  │\n",
      "└─────────┴─────────────┴───────────────────────────────────┴──────────────┴──────────────┴───────────────┴────────────┴────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({labelIntersect: [':regions/China'], startYear, endYear, startMonth, endMonth, groupTimeRange, order, limit: 30}).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8ee19f2a-ad09-4c17-94ae-c80190f5d9bb",
   "metadata": {},
   "source": [
    "## 中国企业活跃度排名"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3de0ee21-0cb6-4b2c-9741-144af7ddbed9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────────┬─────────────────┬──────────────┬──────────────┬───────────────┬─────────────┬─────────────┬────────────────┬─────────────┐\n",
      "│ (index) │       id        │      name       │   activity   │ participants │ issue_comment │ open_issue  │  open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────────┼─────────────────┼──────────────┼──────────────┼───────────────┼─────────────┼─────────────┼────────────────┼─────────────┤\n",
      "│    0    │    'Alibaba'    │    'Alibaba'    │ [ 79512.43 ] │ [ '33280' ]  │  [ '81386' ]  │ [ '18486' ] │ [ '24821' ] │  [ '37083' ]   │ [ '17948' ] │\n",
      "│    1    │     'Baidu'     │     'Baidu'     │ [ 60332.72 ] │ [ '22474' ]  │  [ '68783' ]  │ [ '14901' ] │ [ '22651' ] │  [ '28563' ]   │ [ '17149' ] │\n",
      "│    2    │   'Ant group'   │   'Ant group'   │ [ 56260.29 ] │ [ '26118' ]  │  [ '82960' ]  │ [ '16533' ] │ [ '12574' ] │  [ '13736' ]   │ [ '9719' ]  │\n",
      "│    3    │    'PingCAP'    │    'PingCAP'    │ [ 46202.83 ] │ [ '10575' ]  │ [ '170297' ]  │ [ '7315' ]  │ [ '20882' ] │  [ '46562' ]   │ [ '17176' ] │\n",
      "│    4    │    'Tencent'    │    'Tencent'    │ [ 25724.08 ] │ [ '10849' ]  │  [ '17989' ]  │ [ '7173' ]  │ [ '12629' ] │   [ '4982' ]   │ [ '10754' ] │\n",
      "│    5    │   'QingCloud'   │   'QingCloud'   │ [ 12410.78 ] │  [ '3694' ]  │  [ '27259' ]  │ [ '2530' ]  │ [ '5456' ]  │   [ '4166' ]   │ [ '4809' ]  │\n",
      "│    6    │    'Huawei'     │    'Huawei'     │ [ 10085.51 ] │  [ '3393' ]  │  [ '12304' ]  │ [ '2318' ]  │ [ '3732' ]  │   [ '7227' ]   │ [ '3003' ]  │\n",
      "│    7    │   'Fit2Cloud'   │   'Fit2Cloud'   │ [ 8974.93 ]  │  [ '3575' ]  │  [ '11475' ]  │ [ '4394' ]  │ [ '8043' ]  │   [ '452' ]    │ [ '7177' ]  │\n",
      "│    8    │    'Zilliz'     │    'Zilliz'     │ [ 8600.74 ]  │  [ '1992' ]  │  [ '36578' ]  │ [ '2766' ]  │ [ '8656' ]  │   [ '1386' ]   │ [ '7984' ]  │\n",
      "│    9    │    'Jina AI'    │    'Jina AI'    │ [ 8589.14 ]  │  [ '1826' ]  │  [ '14377' ]  │ [ '1422' ]  │ [ '10036' ] │  [ '10072' ]   │ [ '4139' ]  │\n",
      "│   10    │    'Vesoft'     │    'Vesoft'     │ [ 7963.58 ]  │  [ '2307' ]  │  [ '4583' ]   │ [ '1377' ]  │ [ '4072' ]  │   [ '5883' ]   │ [ '3576' ]  │\n",
      "│   11    │      'EMQ'      │      'EMQ'      │  [ 7450.9 ]  │  [ '2400' ]  │  [ '4269' ]   │ [ '1040' ]  │ [ '4683' ]  │   [ '3399' ]   │ [ '4104' ]  │\n",
      "│   12    │ 'StreamNative'  │ 'StreamNative'  │ [ 6828.53 ]  │  [ '1761' ]  │  [ '13494' ]  │ [ '1361' ]  │ [ '2761' ]  │   [ '6922' ]   │ [ '2374' ]  │\n",
      "│   13    │      'JD'       │      'JD'       │ [ 6461.37 ]  │  [ '3610' ]  │  [ '6704' ]   │ [ '1850' ]  │ [ '1321' ]  │   [ '248' ]    │  [ '919' ]  │\n",
      "│   14    │    'Oneflow'    │    'Oneflow'    │ [ 6140.93 ]  │  [ '1006' ]  │  [ '5138' ]   │  [ '257' ]  │ [ '3446' ]  │  [ '13060' ]   │ [ '2593' ]  │\n",
      "│   15    │   'ByteDance'   │   'ByteDance'   │ [ 5968.93 ]  │  [ '2606' ]  │  [ '3856' ]   │ [ '1573' ]  │ [ '1935' ]  │   [ '1654' ]   │ [ '1559' ]  │\n",
      "│   16    │   'SphereEx'    │   'SphereEx'    │ [ 4953.53 ]  │  [ '1442' ]  │  [ '8845' ]   │ [ '1794' ]  │ [ '3251' ]  │   [ '2417' ]   │ [ '2985' ]  │\n",
      "│   17    │    'Youzan'     │    'Youzan'     │  [ 4279.1 ]  │  [ '2246' ]  │  [ '4355' ]   │ [ '1533' ]  │ [ '1621' ]  │   [ '401' ]    │ [ '1368' ]  │\n",
      "│   18    │     'API7'      │     'API7'      │ [ 4106.58 ]  │  [ '1232' ]  │  [ '7007' ]   │ [ '1177' ]  │ [ '1213' ]  │   [ '4140' ]   │ [ '1043' ]  │\n",
      "│   19    │   'TAOS Data'   │   'TAOS Data'   │ [ 3993.09 ]  │  [ '1212' ]  │  [ '2716' ]   │  [ '697' ]  │ [ '3869' ]  │   [ '498' ]    │ [ '3474' ]  │\n",
      "│   20    │     'Didi'      │     'Didi'      │ [ 3615.89 ]  │  [ '1718' ]  │  [ '2264' ]   │ [ '1108' ]  │ [ '1267' ]  │   [ '205' ]    │ [ '1031' ]  │\n",
      "│   21    │    'VMWare'     │    'VMWare'     │ [ 3612.97 ]  │  [ '1799' ]  │  [ '4861' ]   │ [ '1212' ]  │  [ '813' ]  │   [ '654' ]    │  [ '710' ]  │\n",
      "│   22    │    'Alluxio'    │    'Alluxio'    │ [ 3345.89 ]  │  [ '717' ]   │  [ '7514' ]   │  [ '513' ]  │ [ '1438' ]  │   [ '3782' ]   │ [ '1233' ]  │\n",
      "│   23    │    'Yunion'     │    'Yunion'     │ [ 3251.83 ]  │  [ '588' ]   │  [ '6642' ]   │  [ '289' ]  │ [ '5465' ]  │   [ '279' ]    │ [ '5250' ]  │\n",
      "│   24    │    'Timecho'    │    'Timecho'    │ [ 2951.34 ]  │  [ '621' ]   │  [ '3827' ]   │  [ '254' ]  │ [ '1687' ]  │   [ '2792' ]   │ [ '1485' ]  │\n",
      "│   25    │    'WeBank'     │    'WeBank'     │ [ 2942.06 ]  │  [ '1112' ]  │  [ '1104' ]   │  [ '580' ]  │ [ '1598' ]  │   [ '393' ]    │ [ '1300' ]  │\n",
      "│   26    │    'Taichi'     │    'Taichi'     │ [ 2591.56 ]  │  [ '671' ]   │  [ '3578' ]   │  [ '460' ]  │ [ '1335' ]  │   [ '2659' ]   │ [ '1164' ]  │\n",
      "│   27    │    'Juejin'     │    'Juejin'     │ [ 2518.01 ]  │  [ '559' ]   │  [ '3853' ]   │  [ '667' ]  │  [ '758' ]  │   [ '5282' ]   │  [ '645' ]  │\n",
      "│   28    │   'RT-Thread'   │   'RT-Thread'   │ [ 2462.54 ]  │  [ '790' ]   │  [ '2160' ]   │  [ '148' ]  │ [ '1307' ]  │   [ '1237' ]   │ [ '1018' ]  │\n",
      "│   29    │    'DCloud'     │    'DCloud'     │ [ 2342.46 ]  │  [ '1401' ]  │  [ '2631' ]   │  [ '887' ]  │  [ '174' ]  │    [ '9' ]     │  [ '85' ]   │\n",
      "│   30    │    'Deepin'     │    'Deepin'     │ [ 2303.53 ]  │  [ '1394' ]  │  [ '4550' ]   │  [ '741' ]  │  [ '118' ]  │    [ '21' ]    │  [ '35' ]   │\n",
      "│   31    │   'StarRocks'   │   'StarRocks'   │  [ 2073.2 ]  │  [ '406' ]   │  [ '1744' ]   │  [ '756' ]  │ [ '1601' ]  │   [ '2774' ]   │ [ '1417' ]  │\n",
      "│   32    │    'Xiaomi'     │    'Xiaomi'     │ [ 1973.29 ]  │  [ '821' ]   │   [ '941' ]   │  [ '607' ]  │  [ '737' ]  │   [ '753' ]    │  [ '629' ]  │\n",
      "│   33    │   'OpenResty'   │   'OpenResty'   │ [ 1851.41 ]  │  [ '935' ]   │   [ '981' ]   │  [ '261' ]  │  [ '398' ]  │   [ '363' ]    │  [ '322' ]  │\n",
      "│   34    │    'Netease'    │    'Netease'    │ [ 1697.12 ]  │  [ '879' ]   │  [ '1292' ]   │  [ '589' ]  │  [ '370' ]  │   [ '540' ]    │  [ '93' ]   │\n",
      "│   35    │   'Guojusoft'   │   'Guojusoft'   │ [ 1564.95 ]  │  [ '819' ]   │  [ '2100' ]   │  [ '936' ]  │  [ '21' ]   │    [ '0' ]     │   [ '0' ]   │\n",
      "│   36    │  'Linux China'  │  'Linux China'  │ [ 1502.61 ]  │  [ '276' ]   │   [ '166' ]   │   [ '7' ]   │ [ '3457' ]  │    [ '5' ]     │ [ '3071' ]  │\n",
      "│   37    │   'JuiceData'   │   'JuiceData'   │ [ 1306.83 ]  │  [ '377' ]   │   [ '966' ]   │  [ '350' ]  │  [ '920' ]  │   [ '602' ]    │  [ '850' ]  │\n",
      "│   38    │     'CTrip'     │     'CTrip'     │ [ 1294.21 ]  │  [ '543' ]   │  [ '1612' ]   │  [ '273' ]  │  [ '335' ]  │   [ '410' ]    │  [ '250' ]  │\n",
      "│   39    │    'Megvii'     │    'Megvii'     │ [ 1124.34 ]  │  [ '446' ]   │  [ '1069' ]   │  [ '183' ]  │  [ '424' ]  │   [ '356' ]    │  [ '317' ]  │\n",
      "│   40    │   'Bilibili'    │   'Bilibili'    │ [ 1114.75 ]  │  [ '795' ]   │   [ '897' ]   │  [ '324' ]  │  [ '54' ]   │    [ '4' ]     │  [ '26' ]   │\n",
      "│   41    │   'KodeRover'   │   'KodeRover'   │ [ 1092.32 ]  │  [ '263' ]   │   [ '407' ]   │  [ '125' ]  │ [ '1068' ]  │   [ '933' ]    │  [ '917' ]  │\n",
      "│   42    │    'Meituan'    │    'Meituan'    │ [ 1051.83 ]  │  [ '616' ]   │   [ '659' ]   │  [ '213' ]  │  [ '296' ]  │    [ '32' ]    │  [ '155' ]  │\n",
      "│   43    │   'ThinkPHP'    │   'ThinkPHP'    │  [ 993.92 ]  │  [ '590' ]   │   [ '582' ]   │  [ '357' ]  │  [ '157' ]  │    [ '4' ]     │  [ '75' ]   │\n",
      "│   44    │      '360'      │      '360'      │  [ 953.72 ]  │  [ '574' ]   │   [ '520' ]   │  [ '266' ]  │  [ '206' ]  │    [ '8' ]     │  [ '88' ]   │\n",
      "│   45    │   'Goodrain'    │   'Goodrain'    │  [ 774.08 ]  │  [ '193' ]   │   [ '287' ]   │  [ '95' ]   │  [ '669' ]  │   [ '288' ]    │  [ '566' ]  │\n",
      "│   46    │ 'Matrix Origin' │ 'Matrix Origin' │  [ 551.92 ]  │   [ '93' ]   │   [ '398' ]   │  [ '480' ]  │  [ '671' ]  │    [ '42' ]    │  [ '608' ]  │\n",
      "│   47    │   'Kyligence'   │   'Kyligence'   │  [ 517.46 ]  │  [ '156' ]   │   [ '429' ]   │   [ '0' ]   │  [ '247' ]  │   [ '203' ]    │  [ '203' ]  │\n",
      "│   48    │   'Chatopera'   │   'Chatopera'   │  [ 386.4 ]   │  [ '190' ]   │   [ '596' ]   │  [ '234' ]  │   [ '6' ]   │    [ '0' ]     │   [ '0' ]   │\n",
      "│   49    │   'Bytebase'    │   'Bytebase'    │  [ 320.56 ]  │   [ '61' ]   │   [ '418' ]   │  [ '34' ]   │  [ '271' ]  │   [ '600' ]    │  [ '246' ]  │\n",
      "│   50    │     'Qunar'     │     'Qunar'     │  [ 187.21 ]  │   [ '98' ]   │   [ '116' ]   │  [ '47' ]   │  [ '59' ]   │    [ '0' ]     │  [ '16' ]   │\n",
      "│   51    │ 'Galaxy Future' │ 'Galaxy Future' │  [ 178.7 ]   │   [ '39' ]   │   [ '17' ]    │   [ '7' ]   │  [ '159' ]  │   [ '132' ]    │  [ '142' ]  │\n",
      "│   52    │    'Vipshop'    │    'Vipshop'    │  [ 169.56 ]  │   [ '82' ]   │   [ '50' ]    │  [ '46' ]   │  [ '84' ]   │    [ '14' ]    │  [ '31' ]   │\n",
      "│   53    │    'Douban'     │    'Douban'     │  [ 110.02 ]  │   [ '47' ]   │   [ '43' ]    │  [ '17' ]   │  [ '53' ]   │    [ '8' ]     │  [ '43' ]   │\n",
      "│   54    │  'Cloud Wise'   │  'Cloud Wise'   │  [ 54.96 ]   │   [ '26' ]   │   [ '30' ]    │  [ '18' ]   │  [ '20' ]   │    [ '0' ]     │  [ '14' ]   │\n",
      "│   55    │     'GAAS'      │     'GAAS'      │  [ 52.96 ]   │   [ '30' ]   │   [ '40' ]    │   [ '9' ]   │  [ '12' ]   │    [ '0' ]     │   [ '4' ]   │\n",
      "│   56    │    'ZStack'     │    'ZStack'     │  [ 39.25 ]   │   [ '25' ]   │   [ '27' ]    │   [ '9' ]   │   [ '8' ]   │    [ '0' ]     │   [ '0' ]   │\n",
      "│   57    │     'Oushu'     │     'Oushu'     │  [ 38.01 ]   │   [ '15' ]   │   [ '13' ]    │   [ '0' ]   │  [ '21' ]   │    [ '0' ]     │  [ '20' ]   │\n",
      "│   58    │  'DataCanvas'   │  'DataCanvas'   │  [ 20.79 ]   │   [ '6' ]    │    [ '0' ]    │   [ '7' ]   │  [ '13' ]   │    [ '0' ]     │  [ '12' ]   │\n",
      "│   59    │   'SequoiaDB'   │   'SequoiaDB'   │  [ 14.23 ]   │   [ '9' ]    │    [ '4' ]    │   [ '6' ]   │   [ '2' ]   │    [ '0' ]     │   [ '2' ]   │\n",
      "└─────────┴─────────────────┴─────────────────┴──────────────┴──────────────┴───────────────┴─────────────┴─────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({labelIntersect: [':regions/China', 'Company'], startYear, endYear, startMonth, endMonth, groupTimeRange, order, groupBy: 'Company', limit: -1}).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "abddf2c4-df60-4758-b3b0-bc677521ac15",
   "metadata": {},
   "source": [
    "## Apache 基金会中国项目活跃度 Top 20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d24987cc-7965-4a09-9c1b-8fe1a9221171",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────┬───────────────────────────────────┬─────────────┬──────────────┬───────────────┬────────────┬────────────┬────────────────┬─────────────┐\n",
      "│ (index) │     id      │               name                │  activity   │ participants │ issue_comment │ open_issue │ open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────┼───────────────────────────────────┼─────────────┼──────────────┼───────────────┼────────────┼────────────┼────────────────┼─────────────┤\n",
      "│    0    │ '20587599'  │          'apache/flink'           │ [ 8514.56 ] │  [ '1625' ]  │  [ '14559' ]  │  [ '0' ]   │ [ '3414' ] │  [ '14580' ]   │ [ '1590' ]  │\n",
      "│    1    │ '62117812'  │          'apache/pulsar'          │ [ 6828.53 ] │  [ '1761' ]  │  [ '13494' ]  │ [ '1361' ] │ [ '2761' ] │   [ '6922' ]   │ [ '2374' ]  │\n",
      "│    2    │ '70746484'  │           'apache/tvm'            │ [ 6325.89 ] │  [ '1413' ]  │  [ '7297' ]   │ [ '394' ]  │ [ '1975' ] │   [ '8974' ]   │ [ '1731' ]  │\n",
      "│    3    │ '49876476'  │      'apache/shardingsphere'      │ [ 4953.53 ] │  [ '1442' ]  │  [ '8845' ]   │ [ '1794' ] │ [ '3251' ] │   [ '2417' ]   │ [ '2985' ]  │\n",
      "│    4    │  '9185792'  │         'apache/echarts'          │ [ 4323.98 ] │  [ '2344' ]  │  [ '8031' ]   │ [ '1898' ] │ [ '319' ]  │   [ '375' ]    │  [ '261' ]  │\n",
      "│    5    │ '180481986' │          'apache/apisix'          │ [ 4106.58 ] │  [ '1232' ]  │  [ '7007' ]   │ [ '1177' ] │ [ '1213' ] │   [ '4140' ]   │ [ '1043' ]  │\n",
      "│    6    │ '173335706' │     'apache/dolphinscheduler'     │ [ 3869.77 ] │  [ '1184' ]  │  [ '10237' ]  │ [ '1472' ] │ [ '1554' ] │   [ '1434' ]   │ [ '1264' ]  │\n",
      "│    7    │  '4710920'  │          'apache/dubbo'           │ [ 3313.12 ] │  [ '1277' ]  │  [ '5179' ]   │ [ '882' ]  │ [ '1328' ] │   [ '1006' ]   │ [ '1132' ]  │\n",
      "│    8    │ '45721011'  │        'apache/skywalking'        │ [ 3165.48 ] │  [ '1054' ]  │  [ '5809' ]   │ [ '926' ]  │ [ '783' ]  │   [ '2890' ]   │  [ '689' ]  │\n",
      "│    9    │ '212382406' │          'apache/ozone'           │ [ 3004.05 ] │  [ '514' ]   │  [ '2987' ]   │  [ '0' ]   │ [ '1102' ] │   [ '4253' ]   │  [ '925' ]  │\n",
      "│   10    │ '158975124' │          'apache/iotdb'           │ [ 2951.34 ] │  [ '621' ]   │  [ '3827' ]   │ [ '254' ]  │ [ '1687' ] │   [ '2792' ]   │ [ '1485' ]  │\n",
      "│   11    │ '99919302'  │     'apache/incubator-doris'      │ [ 2881.15 ] │  [ '853' ]   │  [ '2826' ]   │ [ '857' ]  │ [ '1152' ] │   [ '1890' ]   │  [ '987' ]  │\n",
      "│   12    │ '75164823'  │         'apache/rocketmq'         │ [ 2130.52 ] │  [ '878' ]   │  [ '2706' ]   │ [ '603' ]  │ [ '490' ]  │   [ '338' ]    │  [ '246' ]  │\n",
      "│   13    │ '140543886' │     'apache/incubator-shenyu'     │ [ 1286.65 ] │  [ '404' ]   │  [ '1794' ]   │ [ '348' ]  │ [ '606' ]  │   [ '333' ]    │  [ '526' ]  │\n",
      "│   14    │ '143965255' │         'apache/dubbo-go'         │ [ 1251.14 ] │  [ '356' ]   │  [ '1069' ]   │ [ '160' ]  │ [ '497' ]  │   [ '729' ]    │  [ '366' ]  │\n",
      "│   15    │ '62117818'  │        'apache/carbondata'        │ [ 1049.07 ] │  [ '197' ]   │  [ '3838' ]   │  [ '17' ]  │ [ '149' ]  │   [ '1274' ]   │   [ '1' ]   │\n",
      "│   16    │ '114619105' │     'apache/incubator-kyuubi'     │ [ 941.78 ]  │  [ '158' ]   │  [ '1986' ]   │ [ '266' ]  │ [ '458' ]  │   [ '1802' ]   │  [ '25' ]   │\n",
      "│   17    │ '102343794' │      'apache/incubator-brpc'      │ [ 783.52 ]  │  [ '415' ]   │   [ '742' ]   │ [ '198' ]  │ [ '122' ]  │   [ '104' ]    │  [ '74' ]   │\n",
      "│   18    │ '91674936'  │ 'apache/servicecomb-java-chassis' │ [ 753.35 ]  │  [ '313' ]   │  [ '1024' ]   │ [ '293' ]  │ [ '182' ]  │   [ '161' ]    │  [ '154' ]  │\n",
      "│   19    │ '231533573' │     'apache/incubator-tubemq'     │ [ 725.54 ]  │  [ '148' ]   │   [ '683' ]   │ [ '1126' ] │ [ '455' ]  │   [ '314' ]    │  [ '414' ]  │\n",
      "└─────────┴─────────────┴───────────────────────────────────┴─────────────┴──────────────┴───────────────┴────────────┴────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({labelIntersect: [':regions/China', ':foundations/apache'], startYear, endYear, startMonth, endMonth, groupTimeRange, order, limit: 20}).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7be4b4b9-e4d5-4637-85eb-d1d543534712",
   "metadata": {},
   "source": [
    "## CNCF 基金会中国项目活跃度 Top 20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ca26d42b-b83b-4fa5-b333-d65c1c70230b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────┬────────────────────────────────┬─────────────┬──────────────┬───────────────┬────────────┬────────────┬────────────────┬─────────────┐\n",
      "│ (index) │     id      │              name              │  activity   │ participants │ issue_comment │ open_issue │ open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────┼────────────────────────────────┼─────────────┼──────────────┼───────────────┼────────────┼────────────┼────────────────┼─────────────┤\n",
      "│    0    │ '48833910'  │          'tikv/tikv'           │ [ 4766.95 ] │  [ '1018' ]  │  [ '18779' ]  │ [ '636' ]  │ [ '1511' ] │   [ '4472' ]   │ [ '1104' ]  │\n",
      "│    1    │ '50613991'  │       'goharbor/harbor'        │ [ 3612.97 ] │  [ '1799' ]  │  [ '4861' ]   │ [ '1212' ] │ [ '813' ]  │   [ '654' ]    │  [ '710' ]  │\n",
      "│    2    │ '135516270' │          'k3s-io/k3s'          │ [ 3173.79 ] │  [ '1436' ]  │  [ '5465' ]   │ [ '990' ]  │ [ '694' ]  │   [ '1103' ]   │  [ '624' ]  │\n",
      "│    3    │ '276822250' │       'oam-dev/kubevela'       │ [ 2238.21 ] │  [ '471' ]   │  [ '3534' ]   │ [ '579' ]  │ [ '1315' ] │   [ '3135' ]   │ [ '1147' ]  │\n",
      "│    4    │ '206213815' │    'chaos-mesh/chaos-mesh'     │ [ 2154.96 ] │  [ '499' ]   │  [ '7708' ]   │ [ '468' ]  │ [ '801' ]  │   [ '1594' ]   │  [ '692' ]  │\n",
      "│    5    │ '150713223' │      'kubeedge/kubeedge'       │ [ 2111.11 ] │  [ '636' ]   │  [ '4595' ]   │ [ '339' ]  │ [ '631' ]  │   [ '1518' ]   │  [ '437' ]  │\n",
      "│    6    │ '175592968' │      'volcano-sh/volcano'      │ [ 1486.4 ]  │  [ '425' ]   │  [ '3596' ]   │ [ '302' ]  │ [ '351' ]  │   [ '794' ]    │  [ '260' ]  │\n",
      "│    7    │ '311639195' │      'karmada-io/karmada'      │ [ 1460.66 ] │  [ '303' ]   │  [ '4738' ]   │ [ '242' ]  │ [ '553' ]  │   [ '1569' ]   │  [ '466' ]  │\n",
      "│    8    │ '265800635' │     'openyurtio/openyurt'      │ [ 1099.47 ] │  [ '294' ]   │  [ '2293' ]   │ [ '196' ]  │ [ '293' ]  │   [ '765' ]    │  [ '259' ]  │\n",
      "│    9    │ '278954673' │   'fluid-cloudnative/fluid'    │ [ 966.54 ]  │  [ '214' ]   │   [ '714' ]   │ [ '287' ]  │ [ '483' ]  │   [ '803' ]    │  [ '434' ]  │\n",
      "│   10    │ '189490177' │      'openkruise/kruise'       │  [ 956.5 ]  │  [ '261' ]   │  [ '1207' ]   │ [ '120' ]  │ [ '225' ]  │   [ '1306' ]   │  [ '168' ]  │\n",
      "│   11    │ '263214582' │ 'alibaba/inclavare-containers' │ [ 805.27 ]  │  [ '111' ]   │   [ '720' ]   │ [ '452' ]  │ [ '485' ]  │   [ '1668' ]   │  [ '435' ]  │\n",
      "│   12    │ '224908244' │      'WasmEdge/WasmEdge'       │ [ 784.84 ]  │  [ '205' ]   │  [ '1074' ]   │ [ '358' ]  │ [ '351' ]  │   [ '612' ]    │  [ '307' ]  │\n",
      "│   13    │ '177068961' │       'kubeovn/kube-ovn'       │  [ 596.4 ]  │  [ '148' ]   │   [ '265' ]   │  [ '75' ]  │ [ '459' ]  │   [ '265' ]    │  [ '424' ]  │\n",
      "│   14    │ '311269921' │     'nocalhost/nocalhost'      │ [ 572.04 ]  │  [ '117' ]   │   [ '169' ]   │  [ '44' ]  │ [ '962' ]  │    [ '16' ]    │  [ '819' ]  │\n",
      "│   15    │ '309874357' │   'dragonflyoss/Dragonfly2'    │ [ 556.88 ]  │  [ '106' ]   │   [ '606' ]   │ [ '259' ]  │ [ '481' ]  │   [ '353' ]    │  [ '422' ]  │\n",
      "│   16    │ '306631211' │     'alibaba/libvineyard'      │ [ 412.42 ]  │   [ '92' ]   │   [ '483' ]   │ [ '139' ]  │ [ '335' ]  │   [ '178' ]    │  [ '312' ]  │\n",
      "│   17    │ '322759957' │     'superedge/superedge'      │ [ 408.64 ]  │  [ '139' ]   │   [ '181' ]   │  [ '63' ]  │ [ '213' ]  │    [ '92' ]    │  [ '169' ]  │\n",
      "│   18    │ '199763479' │       'bfenetworks/bfe'        │ [ 331.46 ]  │  [ '134' ]   │   [ '206' ]   │  [ '44' ]  │ [ '134' ]  │    [ '45' ]    │  [ '111' ]  │\n",
      "│   19    │ '227010082' │       'kubedl-io/kubedl'       │ [ 306.49 ]  │   [ '88' ]   │   [ '270' ]   │  [ '57' ]  │  [ '86' ]  │   [ '184' ]    │  [ '73' ]   │\n",
      "└─────────┴─────────────┴────────────────────────────────┴─────────────┴──────────────┴───────────────┴────────────┴────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({labelIntersect: [':regions/China', ':foundations/linux_foundation/cncf'], startYear, endYear, startMonth, endMonth, groupTimeRange, order, limit: 20}).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "93c0bb80-3f9b-4456-8245-35afc9d1a872",
   "metadata": {},
   "source": [
    "## Linux Foundation 中国项目活跃度 Top 20"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6e485b38-e8cf-4af9-baa7-f84b04799436",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "┌─────────┬─────────────┬─────────────────────────────────────────────┬─────────────┬──────────────┬───────────────┬────────────┬────────────┬────────────────┬─────────────┐\n",
      "│ (index) │     id      │                    name                     │  activity   │ participants │ issue_comment │ open_issue │ open_pull  │ review_comment │ merged_pull │\n",
      "├─────────┼─────────────┼─────────────────────────────────────────────┼─────────────┼──────────────┼───────────────┼────────────┼────────────┼────────────────┼─────────────┤\n",
      "│    0    │ '208728772' │             'milvus-io/milvus'              │ [ 5047.83 ] │  [ '967' ]   │  [ '30913' ]  │ [ '1990' ] │ [ '6119' ] │   [ '906' ]    │ [ '5617' ]  │\n",
      "│    1    │ '123983554' │        'projectacrn/acrn-hypervisor'        │ [ 1982.36 ] │  [ '394' ]   │  [ '4447' ]   │ [ '377' ]  │ [ '874' ]  │   [ '1566' ]   │  [ '815' ]  │\n",
      "│    2    │ '184341774' │     'cloud-hypervisor/cloud-hypervisor'     │ [ 1206.85 ] │  [ '232' ]   │  [ '1700' ]   │ [ '181' ]  │ [ '1079' ] │   [ '1075' ]   │  [ '955' ]  │\n",
      "│    3    │ '254367182' │           'sodafoundation/delfin'           │ [ 744.04 ]  │  [ '151' ]   │   [ '421' ]   │ [ '117' ]  │ [ '198' ]  │   [ '977' ]    │  [ '151' ]  │\n",
      "│    4    │ '157422219' │               'occlum/occlum'               │  [ 605.7 ]  │  [ '163' ]   │   [ '456' ]   │ [ '133' ]  │ [ '289' ]  │   [ '430' ]    │  [ '251' ]  │\n",
      "│    5    │ '149651594' │        'sodafoundation/multi-cloud'         │ [ 316.77 ]  │   [ '67' ]   │   [ '246' ]   │  [ '90' ]  │  [ '63' ]  │   [ '463' ]    │  [ '45' ]   │\n",
      "│    6    │ '271742278' │            'baetyl/baetyl-cloud'            │ [ 310.72 ]  │   [ '72' ]   │   [ '127' ]   │  [ '5' ]   │ [ '197' ]  │   [ '140' ]    │  [ '186' ]  │\n",
      "│    7    │ '191105638' │       'sodafoundation/documentation'        │ [ 248.73 ]  │   [ '51' ]   │   [ '56' ]    │  [ '12' ]  │  [ '45' ]  │   [ '421' ]    │  [ '37' ]   │\n",
      "│    8    │ '195003588' │                'emqx/kuiper'                │ [ 190.17 ]  │   [ '67' ]   │   [ '194' ]   │  [ '63' ]  │  [ '78' ]  │    [ '24' ]    │  [ '78' ]   │\n",
      "│    9    │ '256235585' │         'cloud-hypervisor/libvirt'          │ [ 163.33 ]  │   [ '41' ]   │   [ '146' ]   │  [ '22' ]  │  [ '49' ]  │   [ '157' ]    │  [ '41' ]   │\n",
      "│   10    │ '304559463' │                'occlum/ngo'                 │ [ 150.38 ]  │   [ '21' ]   │   [ '27' ]    │  [ '11' ]  │ [ '117' ]  │   [ '173' ]    │  [ '96' ]   │\n",
      "│   11    │ '118551918' │   'sodafoundation/architecture-analysis'    │ [ 145.67 ]  │   [ '43' ]   │   [ '21' ]    │  [ '8' ]   │  [ '19' ]  │   [ '146' ]    │  [ '17' ]   │\n",
      "│   12    │ '147453621' │             'TarsCloud/TarsCpp'             │ [ 144.74 ]  │   [ '72' ]   │   [ '109' ]   │  [ '20' ]  │  [ '42' ]  │    [ '0' ]     │  [ '27' ]   │\n",
      "│   13    │ '129361076' │         'sodafoundation/installer'          │ [ 140.52 ]  │   [ '43' ]   │   [ '43' ]    │  [ '27' ]  │  [ '39' ]  │   [ '110' ]    │  [ '37' ]   │\n",
      "│   14    │ '221669123' │             'baetyl/baetyl-go'              │ [ 139.88 ]  │   [ '49' ]   │   [ '51' ]    │  [ '1' ]   │  [ '80' ]  │    [ '9' ]     │  [ '73' ]   │\n",
      "│   15    │ '155232169' │         'sodafoundation/dashboard'          │ [ 139.73 ]  │   [ '41' ]   │   [ '88' ]    │  [ '68' ]  │  [ '60' ]  │    [ '54' ]    │  [ '52' ]   │\n",
      "│   16    │ '181578726' │ 'cloud-hypervisor/rust-hypervisor-firmware' │ [ 134.66 ]  │   [ '47' ]   │   [ '100' ]   │  [ '8' ]   │  [ '68' ]  │    [ '12' ]    │  [ '59' ]   │\n",
      "│   17    │ '148293609' │               'baetyl/baetyl'               │ [ 129.29 ]  │   [ '47' ]   │   [ '38' ]    │  [ '6' ]   │  [ '63' ]  │    [ '28' ]    │  [ '56' ]   │\n",
      "│   18    │ '148576574' │             'TarsCloud/TarsGo'              │ [ 118.67 ]  │   [ '59' ]   │   [ '108' ]   │  [ '21' ]  │  [ '23' ]  │    [ '9' ]     │  [ '18' ]   │\n",
      "│   19    │ '108890846' │          'openmessaging/benchmark'          │ [ 100.63 ]  │   [ '37' ]   │   [ '55' ]    │  [ '11' ]  │  [ '33' ]  │    [ '43' ]    │  [ '31' ]   │\n",
      "└─────────┴─────────────┴─────────────────────────────────────────────┴─────────────┴──────────────┴───────────────┴────────────┴────────────┴────────────────┴─────────────┘\n"
     ]
    }
   ],
   "source": [
    "openDigger.index.activity.getRepoActivity({labelIntersect: [':regions/China', ':foundations/linux_foundation'], startYear, endYear, startMonth, endMonth, groupTimeRange, order, limit: 20}).then(data => {\n",
    "    console.table(data);\n",
    "});"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "JavaScript (Node.js)",
   "language": "javascript",
   "name": "javascript"
  },
  "language_info": {
   "file_extension": ".js",
   "mimetype": "application/javascript",
   "name": "javascript",
   "version": "16.13.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
